package com.changgou.goods.dao;
import com.changgou.goods.pojo.Brand;
import org.apache.ibatis.annotations.Select;
import tk.mybatis.mapper.common.Mapper;

import java.util.List;

/****
 * @Author:admin
 * @Description:Brand的Dao
 * @Date 2019/6/14 0:12
 *****/
public interface BrandMapper extends Mapper<Brand> {





/*    @Select(value="SELECT\n" +
            "    tbb.*\n" +
            "    FROM\n" +
            "    tb_category_brand tbcb,\n" +
            "    tb_brand tbb\n" +
            "    WHERE\n" +
            "    tbb.id = tbcb.brand_id\n" +
            "    AND tbcb.category_id = #{categoryid}")*/

    @Select(value="SELECT tb.* FROM tb_category_brand tcb,tb_brand tb WHERE tcb.category_id=#{categoryid} AND tb.id=tcb.brand_id")
    List<Brand> findByCategory(Integer categoryid);

}
